String functions

String functions are used for the evaluation, manipulation and conversion of text strings.

Len (str)

Length (str)

Trim (str)

LTrim (str)

TrimLeft (str)

RTrim (str)

TrimRight (str)

UCase (str)

UpperCase (str)

LCase (str)

LowerCase (str)

StrReverse (inputString)

IsNumeric (str)

NumericText (str)

ToNumber (numeric), ToNumber (string)

ToText

ToWords (x), ToWords (x, #places)

ReplicateString (str, #copies)

Space (x)

InStr (str1, str2), InStr (start, str1, str2)

InStrRev

StrCmp (str1, str2), StrCmp (str1, str2, compare)

Mid (str, start), Mid (str, start, length)

Left (str, length)

Right (str, length)

Val (str)

Chr (x)

Asc (str)

Filter

Replace

Join

Split